//
//  ShangJiaDataBaseHandle.h
//  Wedding fantastic
//
//  Created by ZLM on 15/7/7.
//  Copyright (c) 2015年 dllo. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <UIKit/UIKit.h>
#import "shangJiaModel.h"
#import <sqlite3.h>
@interface ShangJiaDataBaseHandle : NSObject
+(instancetype)shareDataBase;
-(void)openDB;
-(void)createTable;

-(void)insert:(shangJiaModel *)shangjiaMod;

-(void)updateTable:(shangJiaModel *)shangjiaMod number:(NSInteger)number;
-(void)deleteTable:(NSInteger)number;
-(void)deleteTableByShangJiaName:(NSString *)shangjianame;
-(NSMutableArray *)selectAllshangjia;

-(void)dropTable;
@end
